FaApproveDisbCriteria 
Logical Entity Name  FaApproveDisbCriteria 
Default Table Name  FaApproveDisbCriteria 
Physical Only  NO 
Definition 
 
Note 
 

FaApproveDisbCriteria Columns 
ColumnName  Domain  Datatype  NULL  Definition 
FaApproveDisbCriteriaID(PK)    int  NO 
 
Code    char(10)  NO 
 
Descrip    varchar(40)  NO 
 
MinPctAttFlag    bit  NO 
 
MinPctAtt    numeric(8, 2)  NO 
 
MinHoursAttFlag    bit  NO 
 
MinHoursAtt    numeric(9, 2)  NO 
 
MinNumAvgFlag    bit  NO 
 
MinNumAvg    numeric(11, 6)  NO 
 
MinCumulativeGPAFlag    bit  NO 
 
MinCumulativeGPA    numeric(18, 6)  NO 
 
MinHoursCreditsSchedFlag    bit  NO 
 
MinHoursSched    numeric(18, 2)  NO 
 
MinCreditsSched    numeric(18, 2)  NO 
 
MinHoursCreditsCompFlag    bit  NO 
 
MinHoursComp    numeric(18, 2)  NO 
 
MinCreditsComp    numeric(18, 2)  NO 
 
FACrAttemptEarnedFlag    bit  NO 
 
FACrEarnedAttemp    char(1)  NO 
 
MaxDaysAfterStudLDAFlag    bit  NO 
 
MaxDaysAfterStudLDA    int  NO 
 
MissingDocsFlag    bit  NO 
 
StudSchoolStatusFlag    bit  NO 
 
ReqStudSAPFlag    bit  NO 
 
ReqStudSAP    char(8)  NO 
 
ISIROnFileFlag    bit  NO 
 
AcceptedOriginationFlag    bit  NO 
 
VerifyStatusFlag    bit  NO 
 
VerifyStatus    varchar(25)  NO 
 
MaxDiffDisbAmtFlag    bit  NO 
 
MaxDiffDisbAmt    money  NO 
 
MaxDaysTermDisbDateFlag    bit  NO 
 
MaxDaysTermDisbDate    int  NO 
 
FirstTimeTermStudFlag    bit  NO 
 
MaxDaysFromLoanEndDateFlag    bit  NO 
 
MaxDaysFromLoanEndDate    int  NO 
 
Active    bit  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 
MatchEnrollmentPackagedStatusFlag    bit  NO 
 
EvaluateTerm    bit  NO 
 
CheckAttendanceAll    bit  NO 
 
CheckCompletionDate    bit  NO 
 
CertifiedBeforeLDA    bit  NO 
 
StateofResidencyFlag    bit  NO 
 
StateofResidencyState    char(2)  YES 
 
StateResidentSinceFlag    bit  NO 
 
ResidentYears    smallint  YES 
 
BachelorsDegree    char(1)  NO 
 
GraduateLevelProgram    char(1)  NO 
 
EntranceInterview    bit  NO 
 
MinAdAttStatId(FK)    int  YES 
 
MinPaymentPeriodAttFlag    bit  NO 
 
MinPaymentPeriodAtt    numeric(9, 2)  NO 
 

FaApproveDisbCriteria Primary and Unique Keys 
Key Name  Key Type  Keys 
FaApproveDisbCriteria_Code_U_N_IDX  Index  Code 
FaApproveDisbCriteria_FaApproveDisbCriteriaID_U_C_IDX  PrimaryKey  FaApproveDisbCriteriaID 

FaApproveDisbCriteria Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdAttStat  Non-Identifying  Zero or One to Zero or More  FK_FaApproveDisbCriteria_MinAdAttStatId_AdAttStat_AdAttStatId      MinAdAttStatId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_FaApproveDisbCriteria_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
FaApprovDisbSchoolStatus  Identifying  One To Zero or More  FK_FaApprovDisbSchoolStatus_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID        NO  YES 
FaApproveDisbCriteriaSubsequent  Non-Identifying  One To Zero or More  FK_FaApproveDisbCriteriaSubsequent_FaApproveDisbCriteriaID_FaApproveDisbCriteria_aFaApproveDisbCriteriaID        NO  YES 
FaApproveDisbDocTypes  Identifying  One To Zero or More  FK_FaApproveDisbDocTypes_FaApproveDisbCriteriaID        NO  YES 
FaDisbCriteriaCampusFundSource  Non-Identifying  One To Zero or More  FK_FaDisbCriteriaCampusFundSource_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID        NO  YES 

FaApproveDisbCriteria Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA  ([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0) 
Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg  ([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0) 
Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt  ([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0) 
Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt  ([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0) 
Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched  ([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0)) 
Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp  ([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0)) 
Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate  ([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0) 
Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt  ([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0) 
Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA  ([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0)